EMT Practice Test

1. Question Content...

---

Question1: Why would you create SQL in calculation views?

Question2: In a calculation view, why would you choose the DEPRECATED setting?Note: There are 2 correct answers to this question.

Question3: In your calculation view, you want to consume a custom data source defined using SQLScript.In which type of object do you write your code?

Question4: You implement a referential join between Table A and Table B, but when you query the calculation view, Table B is not pruned.What could be the problem?

Note: There are 2 correct answers to this question.

Question5: How can you define a variable that presents its value help hierarchically?Note: There are 2 correct answers to this question.

Question6: You define a hierarchy in a calculation view. You want to expose the hierarchy to SQL Which of the following conditions must be met?Note: There are 2 correct answers to this question.

Question7: What are the limitations of using a full outer join in a star join node?Note: There are 2 correct answers to this question.

Question8: You have defined a pruning configuration table in a calculation view.What are you attempting to prune from the query execution?

Question9: You want to join two tables in a calculation view.Why do you use a non-equi join?

Question10: Which calendar types can be selected when creating time-based DIMENSIONS?Note: There are 2 correct answers to this question.

Question11: You want to create a star schema using a calculation view. The measures are based on columns from two transaction tables. Dimension calculation views provide the attributes.What is the correct approach?

Question12: In a calculation view, what is the purpose of a variable?

Question13: You created a table and inserted data in it using SQL statements inside the SAP HANA Deployment Infrastructure (HDI) container of your project. You add this table as a data source to a calculation view and try to build it.What do you observe in the SAP HANA database container?

Question14: Referring to the diagram, which privileges would a user require to view United States data when querying the CUBE calculation view?

Question15: What does SAP HANA provide to support full stack native application development?Note: There are 2 correct answers to this question.

Question16: What are some best practices for writing SQLScript for use with calculation views?Note: There are 2 correct answers to this question.

Question17: What are the consequences of NOT executing a delta merge?Note: There are 2 correct answers to this question.

Question18: A calculation view consumes the data sources shown in the graphic. You want to identify which companies sold products in January AND February.

What is the optimal way to do this?

Question19: In SAP Web IDE, you rename a dimension calculation view that is used by a cube calculation view. You do NOT use the option to rename the runtime view and adjust the reference. Afterward, you perform the following build operations:Build the dimension calculation view as a single object.Build the entire SAP HANA database module.What is the outcome of the build operations?

Question20: You have imported a new calculation view in a folder that contains an .hdinamespace file. This calculation view consumes one data source, which is a table. When trying to build the calculation view, the build fails with a namespace-related issue.What could be the reason?Note: There are 2 correct answers to this question.

Question21: What do you use in the definition of a dynamic SQL analytic privilege?

Question22: Your calculation view consumes one data source, which includes the following columns:
SALES_ORDER_ID, PRODUCT_ID, QUANTITY and PRICE.In the output, you want to see summarized data by PRODUCT_ID and a calculated column, PRODUCT_TOTAL, with the formula QUANTITY * PRICE.In which type of node do you define the calculation to display the correct result?

Question23: Why would you enable Debug Query mode in a calculation view?

Question24: Why would you create a multistore table?

Question25: Which of the following are warm data tier solutions?Note: There are 3 correct answers to this question.

Question26: Why would you implement active / active read-enabled mode?

Question27: Using the table in the diagram, you need to create a cube calculation view.What is the simplest approach to create the output from the screenshot?

Question28: What can you identify using Performance Analysis mode?Note: There are 2 correct answers to this question.